Tabela AccountTemplate

Definicja tabeli AccountTemplate

Name

AccountTemplate

Code

AccountTemplate

Comment

 


Lista kolumn tabeli AccountTemplate

Name

Code

AccountTemplateID

AccountTemplateID

DocumentTypeID

DocumentTypeID

BillTypeID

BillTypeID

ContractorID

ContractorID

CalculationTypeID

CalculationTypeID

AnnexNo

AnnexNo

Month

Month

NFZTemplateCorrectionID

NFZTemplateCorrectionID

NFZTemplateID

NFZTemplateID

Year

Year

ContractNo

ContractNo

GenerationMode

GenerationMode

Active

Active

SettlementAnexNumber

SettlementAnexNumber

SettlementTemplateTypeID

SettlementTemplateTypeID

financialPeriodStartDt

financialPeriodStartDt

financialPeriodStopDt

financialPeriodStopDt


Kolumna AccountTemplateID tabeli AccountTemplate

Definicja kolumny AccountTemplateID tabeli AccountTemplate

Name

AccountTemplateID

Code

AccountTemplateID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DocumentTypeID tabeli AccountTemplate

Definicja kolumny DocumentTypeID tabeli AccountTemplate

Name

DocumentTypeID

Code

DocumentTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BillTypeID tabeli AccountTemplate

Definicja kolumny BillTypeID tabeli AccountTemplate

Name

BillTypeID

Code

BillTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractorID tabeli AccountTemplate

Definicja kolumny ContractorID tabeli AccountTemplate

Name

ContractorID

Code

ContractorID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CalculationTypeID tabeli AccountTemplate

Definicja kolumny CalculationTypeID tabeli AccountTemplate

Name

CalculationTypeID

Code

CalculationTypeID

Data Type

NUMBER(5)

Mandatory

No

Comment

ID rodzaju naliczania


Kolumna AnnexNo tabeli AccountTemplate

Definicja kolumny AnnexNo tabeli AccountTemplate

Name

AnnexNo

Code

AnnexNo

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Month tabeli AccountTemplate

Definicja kolumny Month tabeli AccountTemplate

Name

Month

Code

Month

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna NFZTemplateCorrectionID tabeli AccountTemplate

Definicja kolumny NFZTemplateCorrectionID tabeli AccountTemplate

Name

NFZTemplateCorrectionID

Code

NFZTemplateCorrectionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna NFZTemplateID tabeli AccountTemplate

Definicja kolumny NFZTemplateID tabeli AccountTemplate

Name

NFZTemplateID

Code

NFZTemplateID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Year tabeli AccountTemplate

Definicja kolumny Year tabeli AccountTemplate

Name

Year

Code

Year

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractNo tabeli AccountTemplate

Definicja kolumny ContractNo tabeli AccountTemplate

Name

ContractNo

Code

ContractNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna GenerationMode tabeli AccountTemplate

Definicja kolumny GenerationMode tabeli AccountTemplate

Name

GenerationMode

Code

GenerationMode

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Active tabeli AccountTemplate

Definicja kolumny Active tabeli AccountTemplate

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna SettlementAnexNumber tabeli AccountTemplate

Definicja kolumny SettlementAnexNumber tabeli AccountTemplate

Name

SettlementAnexNumber

Code

SettlementAnexNumber

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Numer aneksu ugodowego


Kolumna SettlementTemplateTypeID tabeli AccountTemplate

Definicja kolumny SettlementTemplateTypeID tabeli AccountTemplate

Name

SettlementTemplateTypeID

Code

SettlementTemplateTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

Typ wygenerowanego szablonu do aneksu ugodowego


Kolumna financialPeriodStartDt tabeli AccountTemplate

Definicja kolumny financialPeriodStartDt tabeli AccountTemplate

Name

financialPeriodStartDt

Code

financialPeriodStartDt

Data Type

DATE

Mandatory

No

Comment

Data poczatkowa okresu finansowania


Kolumna financialPeriodStopDt tabeli AccountTemplate

Definicja kolumny financialPeriodStopDt tabeli AccountTemplate

Name

financialPeriodStopDt

Code

financialPeriodStopDt

Data Type

DATE

Mandatory

No

Comment

Data koncowa okresu finansowania


Lista kluczy tabeli AccountTemplate

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli AccountTemplate

Definicja klucza Identifier_1 tabeli AccountTemplate

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment